*************************
* Table A2
*************************

use "citylevel.dta", clear
sum commercialindex residentialindex openspace refugeeshare realestate_exposure age_25_30 growth popdens_2008 pop, d

*

use "capitalflows.dta", clear
sum spread yield_germany eonia policyrate_quarterly vix net_noneuro net_europe inflows_europe outflows_europe lendingspread, d

*

use "firm_data.dta", clear
sum ts_lag industryts_lag ts_inflated_lag equity_lag roa_lag size_lag d_interest d_empl d_capital d_tfp, d

*

use "bank_firm_data.dta", clear
sum d_credit, d

use "bank_data.dta", clear
sum foreignassets netforeignassets_lag interbank_lag bankcapital_lag banksize_lag bankliquidity_lag	bankroa_lag	banknpl_lag	bankloans_lag, d

